Interview Questions

1. What is Control Flow?

Options:

a. Orders the work flow of SSIS package

b. Used to perform ETL (Extract, transform, Load) operation

c. It encapsulates the data flow engine that moves data between sources and destinations

Reveal Answer

2. Control Flow Contains?

Options:

a. Tasks

b. Container

c. Precedence constraints

d. All the above

Reveal Answer

3. The Data Profiling task works only with data that is stored in SQL Server. It does not work with third-party or file-based data sources? Is It true or not?

Options:

a. True

b. False

Reveal Answer

4. You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of development effort. What should you use?

Options:

a. Expression task

b. Script task

c. Execute SQL task

d. Execute Process task

e. Term Extraction transformation

Reveal Answer

5. Which are valid control flow containers?

Options:

a. For Loop Container

b. While Loop Container

c. Sequence Container

d. Generic Container

Reveal Answer

6. Which languages can be used to code a script task?

Options:

a. C#.NET

b. VB.NET

c. T-SQL

d. Java

Reveal Answer

7. The SSIS task that is used to review source data entities, check the cleanliness and completeness of data and to understand how data is organized structurally is:

Options:

a. Script Task

b. Data Validation Task

c. Data Profiling Task

d. Data Exploration Task

Reveal Answer

8. What is the function of the Read Only Variables and Read Write Variables lists included as part of the SSIS Script Task configuration?

Options:

a. Only variables included in one of these lists can be referenced from a script task

b. These lists are not a feature of the Script Task

c. These lists are used to declare new variables that will be available to subsequent control flow tasks

Reveal Answer

9. What type of task can be used to execute the following SQL during SSIS package execution? UPDATE Production.Product SET ProductLine = 's' WHERE ProductLine IS NULL?

Options:

a. Data Destination Task

b. Execute SQL Task

c. Data Source Task

d. SQL Server Task

Reveal Answer

10. Which Task is used to perform file and folder options such as coping, moving, deleting, creating?

Options:

a. Script Task

b. Expression Task

c. File System Task

d. Data Exploration Task

Reveal Answer

11. Which Statement is Correct about For loop container?

Options:

a. It requires variable to perform operations

b. It does not requires variables to perform operations

c. It requires variables but does not perform operations

Reveal Answer

12. Which Container is used to group and control execution order of package?

Options:

a. Sequence Container

b. For Loop Container

c. For Each Loop Container

d. generic container

Reveal Answer

13. Which Task is used to Backup of Sql server database?

Options:

a. Script Task

b. Backup Data Base Task

c. Backup Sql Task

d. None of the Above

Reveal Answer

14. How to copy a database within the same server?

Options:

a. By using Transfer Database Task

b. By using Copy Database Task

c. By using Script Task

d. All the Above

Reveal Answer

15. FTP Task can be used for?

Options:

a. Copying directories and data files from one directory to another

b. Downloading files from an FTP location

c. All the Above

d. None of the Above

Reveal Answer

16. What is the Purpose of History Cleanup Task?

Options:

a. Deletes entries in the history tables in the SQL Server msdb database

b. Performs different types of SQL Server database backups

c. Runs SQL Server Agent jobs

d. Checks the allocation and structural integrity of database objects and indexes

Reveal Answer

17. What conditions can be given to precedence constraints?

Options:

a. Expression

b. Constraint

c. All of the above

d. None of the above

Reveal Answer

18. Which options can be used to group/ungroup components?

Options:

a. Event Handlers

b. Control Flow Tasks

c. Data Flow Tasks

d. Maintenance Tasks

Reveal Answer

19. You design a SQL Server 2008 Integration Services (SSIS) package. The package assigns a value to a variable by using a Script task. When the package executes successfully, the value of the variable is not updated. You need to modify the package so that the Script task can assign the value of the variable. What should you do?

Options:

a. Modify the Raise Changed Event property of the variable

b. Modify the variable scope to the script task

c. Modify the variable scope to the package

d. Modify the Evaluate As Expression property of the variable

Reveal Answer

20. Difference between for loop and for each loop container?

Options:

a. For loop based on conditions and for each loop based on objects collections.

b. For loop based on objects collections and for each loop based on objects collections

c. None

d. Both a and b

Reveal Answer

Interview Questions and Answer

1. What is Control Flow?

2. Control Flow Contains?

3. The Data Profiling task works only with data that is stored in SQL Server. It does not work with third-party or file-based data sources? Is It true or not?

4. You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of development effort. What should you use?

5. Which are valid control flow containers?

6. Which languages can be used to code a script task?

7. The SSIS task that is used to review source data entities, check the cleanliness and completeness of data and to understand how data is organized structurally is:

8. What is the function of the Read Only Variables and Read Write Variables lists included as part of the SSIS Script Task configuration?

9. What type of task can be used to execute the following SQL during SSIS package execution? UPDATE Production.Product SET ProductLine = 's' WHERE ProductLine IS NULL?

10. Which Task is used to perform file and folder options such as coping, moving, deleting, creating?

11. Which Statement is Correct about For loop container?

12. Which Container is used to group and control execution order of package?

13. Which Task is used to Backup of Sql server database?

14. How to copy a database within the same server?

15. FTP Task can be used for?

16. What is the Purpose of History Cleanup Task?

17. What conditions can be given to precedence constraints?

18. Which options can be used to group/ungroup components?

20. Difference between for loop and for each loop container?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources